package db;

import java.sql.SQLException;
import java.util.ArrayList;

import model.Service;

public interface IFService
{
	public ArrayList<Service> searchServicesByAllInfo(boolean type, boolean active, String search) throws SQLException;

	public ArrayList<Service> getAllServices(boolean type, int active) throws SQLException;

	public int createServices(int reqID,Service service, boolean type) throws SQLException;
	
	public int transferServices(int reqID,Service service, boolean type) throws SQLException;

	public int updateServices(Service service, boolean type) throws SQLException;

	public int changeStatus(int status,int id) throws SQLException;

	public Service getOne(int id)  throws SQLException;

	public ArrayList<Service> searchServicesByCity(String city, boolean active, boolean type) throws SQLException;

	public ArrayList<Service> searchServicesByDimension(String dimension, boolean active, boolean type) throws SQLException;

	public ArrayList<Service> searchServicesByCountry(String country, boolean active, boolean type) throws SQLException;

	public ArrayList<Service> searchServicesByCountryTld(String country_tld,boolean active, boolean type) throws SQLException;

	public ArrayList<Service> searchServiceByPrice(double price, boolean active, boolean type);

	public ArrayList<Service> searchServicesByDeadline(String deadline, boolean active, boolean type) throws SQLException;

	public ArrayList<Service> searchServicesByCustomer(String customer, boolean active, boolean type) throws SQLException;

	public ArrayList<Service> searchServicesByDrawingNo(int drawingNo, boolean active, boolean type) throws SQLException;

	public ArrayList<Service> searchServicesByProdQuantity(int quantity, boolean active, boolean type) throws SQLException;

	public ArrayList<Service> searchServicesByName(String name, boolean active, boolean type) throws SQLException;
}
